Problem Note 60797: "ERROR: [SAS...][ODBC Greenplum Wire Protocol driver]Connection refused" occurs when using the TKTS driver against a Greenplum database
 |  |  |  |  |
Using SAS/ACCESS® Interface to Greenplum and the Threaded Kernel Table Services (TKTS) driver to access a Greenplum database results in an error similar to the following:
ERROR: CLI error trying to establish connection: ERROR: [SAS ACCESS to
Greenplum][ODBC Greenplum Wire Protocol driver]Connection refused.
Verify Host Name and Port Number. : ERROR: [SAS ACCESS to
Greenplum][ODBC Greenplum Wire Protocol driver]Can't connect to server
on 'greenplum_server' : Unable to set driver connection attribute
ERROR: Error in the LIBNAME statement.
Greenplum][ODBC Greenplum Wire Protocol driver]Connection refused.
Verify Host Name and Port Number. : ERROR: [SAS ACCESS to
Greenplum][ODBC Greenplum Wire Protocol driver]Can't connect to server
on 'greenplum_server' : Unable to set driver connection attribute
ERROR: Error in the LIBNAME statement.
You encounter this issue when the database is not running on the default port (5432). This issue affects in-database procedures such as %INDGP_PUBLISH_MODEL but does not affect normal LIBNAME connections that do not use TKTS.
The workaround is to set the port to 5432 in the database.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum | Microsoft® Windows® for x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 |
| Microsoft Windows 8 Enterprise 32-bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.41 | 9.42 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Threaded Kernel Extension for Greenplum 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3P.html#60797A fix for this issue for SAS Threaded Kernel Extension for Greenplum 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3Q.html#60797| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> GreenPlum |
| Date Modified: | 2017-11-16 14:41:58 |
| Date Created: | 2017-07-21 11:34:47 |